﻿#region Using namespaces

using System;
using System.Collections.Generic;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data.SQLite;
using System.Linq;
using System.Text;

using BOL.Apps.GeneNetworkBrowser.Properties;

#endregion

namespace BOL.Apps.GeneNetworkBrowser.Databases
{
    [Database]
    public class Microarray_Affymetrix : DataContext
    {
        public Microarray_Affymetrix()
            : base(new SQLiteConnection(Settings.Default.Microarray_Affymetrix)) { }

        public Table<HGU133Plus2> HGU133Plus2;
        public Table<HGU133AB> HGU133AB;
    }

    [Table(Name="HG-U133+2")]
    public class HGU133Plus2
    {
        [Column]
        public string ProbesetID { get; set; }
        [Column]
        public int GeneID { get; set; }
    }

    [Table(Name = "HG-U133AB")]
    public class HGU133AB
    {
        [Column]
        public string ProbesetID { get; set; }
        [Column]
        public int GeneID { get; set; }
    }
}
